/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50731
 Source Host           : 127.0.0.1:3306
 Source Schema         : mybatis-plus

 Target Server Type    : MySQL
 Target Server Version : 50731
 File Encoding         : 65001

 Date: 16/08/2020 17:14:53
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for order_info
-- ----------------------------
DROP TABLE IF EXISTS `order_info`;
CREATE TABLE `order_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '订单唯一ID',
  `user_id` int(11) NOT NULL COMMENT '关联用户user_info.id',
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '收货地址',
  `ori_amt` decimal(20,0) NOT NULL COMMENT '原始总金额',
  `dis_amt` decimal(20,0) NOT NULL COMMENT '实扣总金额',
  `goods_info` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '商品信息',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of order_info
-- ----------------------------
BEGIN;
INSERT INTO `order_info` VALUES (1, 12, '地址108', 110, 100, '商品559');
COMMIT;

-- ----------------------------
-- Table structure for user_base_info
-- ----------------------------
DROP TABLE IF EXISTS `user_base_info`;
CREATE TABLE `user_base_info` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '唯一默认ID',
  `u_name` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '姓名',
  `u_age` int(4) NOT NULL COMMENT '年龄0-9999',
  `u_work` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '工作',
  `u_hobby` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '爱好',
  `u_phone` varchar(13) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '手机号,一般是11位',
  `create_time` datetime NOT NULL COMMENT '记录创建时间',
  `update_time` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '记录更新时间',
  `version` int(11) DEFAULT NULL COMMENT '乐观锁的版本号',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='测试用户信息表';

-- ----------------------------
-- Records of user_base_info
-- ----------------------------
BEGIN;
INSERT INTO `user_base_info` VALUES (1, 'zjf', 28, 'java开发', '敲代码', '12345678912', '2020-08-14 19:49:43', '2020-08-14 12:28:03', NULL);
INSERT INTO `user_base_info` VALUES (2, 'zjf', 18, 'java开发', '敲代码', '12345678912', '2020-08-14 19:49:43', '2020-08-14 11:50:50', NULL);
INSERT INTO `user_base_info` VALUES (3, 'zjf', 18, 'java开发', '敲代码', '12345678912', '2020-08-14 19:49:43', '2020-08-14 11:51:12', NULL);
INSERT INTO `user_base_info` VALUES (4, 'zjf', 18, 'java开发', '敲代码', '12345678912', '2020-08-14 19:49:43', '2020-08-14 11:51:53', NULL);
INSERT INTO `user_base_info` VALUES (5, 'zjf', 18, 'java开发', '敲代码', '12345678912', '2020-08-14 19:49:43', '2020-08-14 11:52:26', NULL);
INSERT INTO `user_base_info` VALUES (6, 'zjf', 18, 'java开发', '敲代码', '12345678912', '2020-08-14 19:49:43', '2020-08-14 11:52:36', NULL);
INSERT INTO `user_base_info` VALUES (7, 'zjf', 18, 'java开发', '敲代码', '12345678912', '2020-08-14 19:49:43', '2020-08-14 11:54:06', NULL);
INSERT INTO `user_base_info` VALUES (8, 'zjf', 359, 'java开发', '敲代码', '12345678912', '1970-01-19 11:43:26', '2020-08-14 11:56:23', NULL);
INSERT INTO `user_base_info` VALUES (9, 'zjf', 763, 'java开发', '敲代码', '12345678912', '1970-01-19 11:43:26', '2020-08-14 11:57:22', NULL);
INSERT INTO `user_base_info` VALUES (10, 'zjf', 826, 'java开发', '敲代码', '12345678912', '1970-01-19 11:43:26', '2020-08-14 11:57:24', NULL);
INSERT INTO `user_base_info` VALUES (11, 'zjf', 278, 'java开发', '敲代码', '12345678912', '1970-01-19 11:43:26', '2020-08-14 11:57:26', NULL);
INSERT INTO `user_base_info` VALUES (13, 'zjf', 643, 'java开发', '敲代码', '12345678912', '1970-01-19 11:43:28', '2020-08-14 12:31:02', NULL);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
